Previous Topic

Next Topic

To modify a custom table

Caution! If your custom table contains customized objects (triggers, additional indexes, special permissions), they will be lost when the table is rebuilt.

  1. Make sure all other users exit the iMIS system.
  2. Back up your data.
  3. Log on as the database owner: MANAGER!SA (Sybase: MANAGER!DBA)
  4. From Customers, select Set up module> General, and click Additional Windows to open the Customer Setup – Additional Windows window.
  5. Click Define Tables to open the User Defined Tables window.
  6. Select the Table Name drop-down list, and select the table you want to modify.
  7. Make the necessary changes:
    • To add a field to the table, place the cursor anywhere in the field row where you want the new field to follow, and click Insert Line on the User Defined Tables window. A new field row is inserted, and the new field information can be added here.
    • To delete a field on the table, place the cursor anywhere in the field, and click Delete Line on the User Defined Tables window.
    • To reorder the fields, select the field, and click Up or Down on the User Defined Tables window.
  8. Click Save. iMIS prompts you to update the server table.
  9. Click Yes.
  10. Click OK if prompted to restart iMIS.
  11. Click Auto-Create Window.
  12. Click Close to close the User Defined Tables window.
  13. Exit iMIS immediately.
  14. Refresh the iMIS libraries by replacing the existing imismem.lbr and imisutil.lbr files with a clean copy of these files.

    Note: If you copy the library files from a CD, make sure to disable the Read only option.

See Also

Creating a Custom Table

User Defined Tables window

To create a custom table

To delete a custom table


ASI logo 10.6 Production Release. Updated 2/21/2006 12:41:09 PM
Copyright © by Advanced Solutions International, Inc. All rights reserved.